prepare('DELETE FROM mcategory WHERE sn =:uid');
$stmt_delete->bindParam(':uid',$_GET['delete_id']);
$stmt_delete->execute();
header("Location: mcategory.php");
}
if(isset($_POST['btnsave']))
{
$catname = $_POST['catname'];// user email
//check if the category has been registerd b4
$chk= $DB_con->prepare("select * from mcategory where (names = :cat)") ;
$chk->bindparam(':cat',$catname) ;
$chk->execute() ;
if($chk->rowcount() > 0)
{
$errMSG = "This Category has been Registered Before, Register Another one";
}
else
{
//$username = $_POST['user_name'];// user name
$sql = $DB_con->prepare("insert into mcategory(names)values(:nm)") ;
$sql->bindparam(':nm',$catname) ;
//$sql->execute() ;
if($sql->execute())
{
$successMSG = "new record succesfully inserted ...";
}
else
{
$errMSG = "error while inserting....";
}
}
}
// view all
?>
Adding Category